Introduction of SQL server
Install SQL Server And SQL Server Management Studio
Create, Rename, and Delete Database
Create, Delete and rename table in SQL server database
Add, Rename And Delete column name
Records insert, update & delete
Select statement
Select Unique and Distinct statement
Select into statement
Insert, update and delete statement
Aggregate function count, max, min, sum, avg
What are SQL Joins
Introduction to Group by Clause
Introduction to Having Clause
Introduction to Order by clause
Introduction to Where clause
AND & OR Operator
Arithmetic Operator
Between Operator
Comparison Operator
While loop
Break and continue statement
Introduction to Stored Procedures
Select Statement Inside the Stored procedure
Insert Statement Inside a Stored Procedure
Update Statement within the Stored Procedure
Input Parameters in a Stored Procedures
Output Parameters in a Stored Procedure
Return Values in a Stored Procedure
Insert Stored Procedure output into Temporary Table
Introduction to function
Introduction to SQL View
Useful System Stored Procedures
In this tutorial, we will learn How to Create, Delete and modify database table Column in SQL server database?
After creating a new table, you may need to add new columns to your existing table, and sometimes you may need to delete or rename the existing column, Let's see how we can do that
Add new column in existing table
minimal syntax is:
ALTER TABLE table_name ADD column_name column_datatype;
You can also add multiple column at the same time syntax is:
ALTER TABLE table_name
ADD (column_1 column_datarype,
column_2 column_datatype,
...
column_n column_datatype);
Example:
Use abctutorial /*Use Your_database_name*/
ALTER TABLE Users ADD UserPassword nvarchar(50);
Rename the existing column
minimal syntax is:
EXEC sp_rename 'table_name.old_column', 'new_name', 'COLUMN';
Example:
Use abctutorial /*Use Your_database_name*/
EXEC sp_rename 'Users.UserPassword', 'UserPwd', 'COLUMN';
Delete the existing column
minimal syntax is:
ALTER TABLE table_name
DROP COLUMN column_name;
Example:
Use abctutorial /*Use Your_database_name*/
ALTER TABLE Users
DROP COLUMN UserPwd;
About Teacher
Comments
